/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package queenb.web.inteface;

import java.sql.SQLException;
import java.util.Date;
import java.util.List;
import queenb.net.entitybean.N100;

/**
 *
 * @author Thanh Luan
 */
public interface EmployeeInf {

    // Thanh Luan Start Create 15/05/2012
    /**
     * update | add new employee
     *
     * @param pn100
     * @param fn600
     * @param fk100
     * @param fh200
     * @param nv102
     * @param nv103
     * @param ni104
     * @param ni105
     * @param nv106
     * @param nv107
     * @param nv108
     * @param nv109
     * @param nv110
     * @param nv111
     * @param nv112
     * @param nv113
     * @param nv114
     * @param nv115
     * @param nv116
     * @param nv117
     * @param pnLogin
     * @return
     * @throws SQLException
     *
     */
    public int updateN100By(
            int pn100,
            int fn600,
            int fk100,
            int fh200,
            String nv102,
            String nv103,
            int ni104,
            int ni105,
            String nv106,
            String nv107,
            String nv108,
            String nv109,
            String nv110,
            String nv111,
            String nv112,
            String nv113,
            int nv114,
            String nv115,
            String nv116,
            int nv117,
            Date pdND118,
            String nv119,
            String nv122,
            String nv123,
            Date nd124,
            Date nd125,
            String nv126,
            String nv127,
            String nv129,
            String nv130,
            Date pdND131,
            int fh000,
            int fn550,
            int fk300,
            int fk350,
            String pnLogin);

    // chuyển nhân viên qua kahch hang tiềm năng
    public int convertEmtoCus(int pnPN100, String pvNV106, String pnLogin);

    public int deleteEmployee(int pn100, String pnLogin);
    // check email exist

    public int checkMailExist(String pvNV105, String pnLogin);
    // check email exist

    public int checkMobiExist(String pvNV109, String pnLogin);
    public int checkMobiCMND(String pvNV109, String pnLogin);
   
    /*
     * CHECK LOGIN EXIT param pvLOGIN
     */
    public List<N100> getAllListTabN100(int fh00, int fh200, int pnPN100, int pnFN450, int pnFN850, String nv103, String pvLogin);

    public List<N100> getAllListTabN100All(int fh00, int fh200, int pnFN100, int pnFN450, int pnFN850, int pnFK400, String nv103, int offset, int limit, int sort, int direction, String pvLogin);

    public List<N100> getAllListTabN100R(int fh00, int fh200, int pnPN100, int pnFN450, int pnFN850, String pvLogin);
// Excel

    public List<N100> getListN100OutExcel(int fh00, int fh200, int fn450, int fn850, String pvLogin);

    public List<N100> getListN100ById(int pn100, String pvLogin);
    // Tim kiem theo nguoi dai dien 

    public List<N100> getListpersonalDD(int pnFH000, int pnFH200, String keysrearch, String pvLOGIN);

    public List<N100> getListComN100D(int pnFH000, int pnFH200, int pnFK100, String pvLOGIN);
    // Thanh Luan End Create 15/05/2012

    public List<N100> getListComN100Project(int pnFH000, int pnFH200, String pvLOGIN);
    // tim theo msnv

    public List<N100> getListComN100NMSNV(int pnFH000, int pnFH200, int pnFN450, int pnFN850, String keysearch, int offset, int limit, int sort, int direction, String pvLOGIN);

    // Tìm theo hoten
    public List<N100> getListComN100Name(int pnFH000, int pnFH200, int pnFN450, int pnFN850, String keysearch, int offset, int limit, int sort, int direction, String pvLOGIN);
    // Tìm theo Email

    public List<N100> getListComN100Email(int pnFH000, int pnFH200, int pnFN450, int pnFN850, String keysearch, int offset, int limit, int sort, int direction, String pvLOGIN);
    // Tìm theo Mobile

    public List<N100> getListComN100Mobile(int pnFH000, int pnFH200, int pnFN450, int pnFN850, String keysearch, int offset, int limit, int sort, int direction, String pvLOGIN);
    //Tim theo cmnd/passport

    public List<N100> getListComN100Passport(int pnFH000, int pnFH200, int pnFN450, int pnFN850, String keysearch, int offset, int limit, int sort, int direction, String pvLOGIN);

    public int updateColumnOneTable(String pvSCHEMA,
            String pvTABNAME,
            String pvCOLNAME,
            String pnVALUE,
            String pvPRIMARYKEY,
            int pnCONDITION,
            String pvLOGIN);

    public int updateColumnLogoN100(int pnPN100, byte[] pnVALUE, String pvLOGIN);
//26/11/2012 myhai :  search alpha

    public List<N100> lstSearchAlpha(int pnFH000, int pnFH200, int pnFN450, int pnFN850, String pvSEARC, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN);

    public int updateColumnLongText(String pvSCHEMA,
            String pvTABNAME,
            String pvCOLNAME,
            String pnVALUE,
            String pvPRIMARYKEY,
            int pnCONDITION,
            String pvLOGIN);

    public List<N100> listT950CNKH(int pnFH000, int pnFH200, String keySearch, String pvLOGIN);// Tìm kiếm KHACH hàng trong công nợ

    public List<N100> comboboxForTour(int pnFH000, int pnFH200, int FV050, String pvLOGIN);

    public List<N100> getAllListTabN100AllBR(int pnFH000, int pnFH200, String pvLOGIN);
    // Employee Delete
     public List<N100> getNCURPKS_LISTOFTABN100NDEL(int pnFH000, int pnFH200,int pnFN100, int pnFN450, int pnFN850,int FK400, String pvSEARC, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN);
     // danh sach nhan vien nghi phep
     public List<N100> getNCURPKS_LISTOFTABN100NHD(int pnFH000, int pnFH200,int pnFN100, String pvLOGIN);
      public List<N100> getAllListTabN100AllBRC(int pnFH000, int pnFH200, String pvLOGIN);
      
      // tim kiem status LISTN100_BIR
        public List<N100> LISTOFTABN100STA(int pnFH000, int pnFH200, int pnPN100,int pnNN104, int pnFK330,Date pdMONFR,Date pdMONTO,int pnOFFSET,int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN);
         public List<N100> NCURPKS_LISTOFTABN100BDAY(int pnFH000, int pnFH200,int pnFN600,Date pdMONFR,Date pdMONTO, String pvLOGIN);
         public List<N100> ncurpks_listoftabn100lcon(int pnFH000, int pnFH200, int pnFH600, String pvLOGIN);
} 
